﻿IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'SelectConstraintTypeByName')
	BEGIN
		DROP  Procedure  SelectConstraintTypeByName
	END

GO

CREATE Procedure SelectConstraintTypeByName
	(
		@name varchar(255)
	)


AS
Select CONS_TYP_ID,CONS_TYP_NAME from CONSTRAINT_TYPE 
Where CONS_TYP_NAME=@name

GO

/*
GRANT EXEC ON Stored_Procedure_Name TO PUBLIC

GO
*/

